Search results for "Visual Basic"
showing 9 items of 9 documents
Parametric Hull Design with Rational Bézier Curves
2021
AbstractIn this paper, a tool able to support the sailing yacht designer during the early stage of the design process has been developed. Quadratic and cubic Rational Bézier curves have been selected to describe the main curves defining the hull of a sailing yacht. The adopted approach is based upon the definition of a set of parameters, say the length of water line, the beam of the waterline, canoe body draft and some dimensionless coefficients according to the traditional way of the yacht designer. Some geometrical constraints imposed on the curves (e.g. continuity, endpoint angles) have been conceived aimed to avoid unreasonable shapes. These curves can be imported in any commercial CAD …
Automatic regrouping of strata in the goodness-of-fit chi-square test
2019
Pearson’s chi-square test is widely employed in social and health sciences to analyze categorical data and contingency tables. For the test to be valid, the sample size must be large enough to provide a minimum number of expected elements per category. This paper develops functions for regrouping strata automatically no matter where they are located, thus enabling the goodness-of-fit test to be performed within an iterative procedure. The functions are written in Excel VBA (Visual Basic for Applications) and in Mathematica. The usefulness and performance of these functions is illustrated by means of a simulation study and the application to different datasets. Finally, the iterative use of …
A procedure to calculate the five-parameter model of crystalline silicon photovoltaic modules on the basis of the tabular performance data
2013
Abstract Only few manufactures provide the wide set of graphical data that are necessary to use high performance predictive tools for PV systems. On the other hand, reliable graphical data require accurate laboratory measurements that increase manufacturing costs. For this reason PV system designers have to choose between the use of cheap PV modules, lacking in technical data, and the reliable energy predictions that are possible only if the current–voltage characteristics are provided by the PV module manufacturers. This paper describes the procedure to evaluate the parameters of a one-diode equivalent circuit able to accurately represent the electrical behaviour of a PV panel by means of …
A user-friendly control system to easy reconfigure a manufacturing cell
2006
Generic manufacturing enterprises need to interact with an environment characterized by a strong competition. In order to react to the mutable requests of market, control systems should confer to the manufacturing system capabilities for easy modifiability, and this can be achieved by reducing the necessary time to reconfigure the existing system. Following this main requirement, this paper presents a user-friendly control system that pursues three operational goals: - Ability to easy re-program the sequence of operations of the manufacturing equipments of a manufacturing cell; - Reconfigurability of the system, by allowing to add/remove a new/existing component in/from the manufacturing ce…
An improved five-parameter model for photovoltaic modules
2010
This paper presents a new five-parameter model capable of analytically describing the I–V characteristic of a photovoltaic module for each generic condition of operative temperature and solar irradiance. The parameters of the equivalent electrical circuit are extracted by solving a system of equations based on data commonly issued by manufacturers in standard rating conditions with a trial and error process. The procedure, which does not require any special equations solver, can be easily coded into a short software routine using simple languages and finds the solution of the system of equations with the desired accuracy without needing to be guided towards solutions starting from fitted in…
VBA-ohjelmoinnin mahdollisuudet raportoinnin ja etähuollon kehityksessä
2005
Supporting Impact Analysis by Program Dependence Graph Based Forward Slicing
2007
Since software must evolve to meet the typically changing requirements, source code modifications can not be avoided. Impact analysis is one of the central and relatively demanding tasks of software maintenance. It is constantly needed while aiming at ensuring the correctness of the made modifications. Due to its importance and challenging nature automated support techniques are required. Theoretically, forward slicing is a very suitable technique for that purpose. Therefore, we have implemented a program dependence graph (PDG) based tool, called GRACE, for it. For example, due to the typical rewritings of Visual Basic programs there is a great need to support their impact analysis. However…
Datu izmaiņu pārlūkošanas moduļa izstrāde nekustamā īpašuma nodokļa administrēšanas sistēmai NINO
2018
Darbā aprakstīta izstrādes gaita nekustamā īpašuma nodokļa administrēšanas sistēmas NINO papildinājuma – datu izmaiņu pārlūkošanas moduļa - risinājumam. Tas paredzēts NINO lietotājiem ērtākai un savām vajadzībām pielāgojamai datu izmaiņu vēstures pārlūkošanai. Risinājums atvieglo gan Latvijas pašvaldību nodokļu inspektoru darbu, gan šo darbinieku kontroli ar datu izmaiņām saistītos jautājumos, kā arī samazina nepieciešamību griezties pēc palīdzības pie NINO klientu konsultantiem. Datu izmaiņu vēsturi iespējams attēlot uz ekrāna vai izklājlapu lietotnē Microsoft Excel, saņemot informāciju, kāds lietotājs, kad un kā izmainījis konkrēta NINO objekta datus. Programmprodukta izstrāde veikta, iev…
Excel ja laskenta pilvipalveluissa
2013
Tutkielma esittelee ja vertailee taulukkolaskenta-ohjelmien ohjelmointimahdollisuuksia. Taulukkolaskentaohjelmia on mahdollisuus käyttää perinteisenä työpöytäsovelluksena, pilvipalveluna verkkoselaimella sekä etäpalvelimen asiakasohjelmalla. Lisää suoritustehoa on saatavilla rinnakkaislaskennalla ja pilvipalveluntarjoajilta. The thesis examines and compares spreadsheet programs and their programming options. Spreadsheet programs have the option to use as a traditional desktop application, a web browser, as well as run the application server with remote client. More processing power is available by using parallel computing and from cloud service providers.